To be able to edit code and run cells, you need to run the notebook yourself. Where would you like to run the notebook?

This notebook takes about 4 minutes to run.

In the cloud (experimental)

Binder is a free, open source service that runs scientific notebooks in the cloud! It will take a while, usually 2-7 minutes to get a session.

On your computer

(Recommended if you want to store your changes.)

  1. Copy the notebook URL:
  2. Run Pluto

    (Also see: How to install Julia and Pluto)

  3. Paste URL in the Open box

Frontmatter

If you are publishing this notebook on the web, you can set the parameters below to provide HTML metadata. This is useful for search engines and social media.

Author 1
Error message

ArgumentError: `DataFrame` constructor from a `Matrix` requires passing :auto as a second argument to automatically generate column names: `DataFrame(matrix, :auto)`

Stack trace

Here is what happened, the most recent locations are first:

  1. DataFrames.DataFrame(matrix::Matrix{Float64})
  2. rar = @view DataFrame(rand(100,3))[2:2]
You got this!
👀 Reading hidden code
rar = @view DataFrame(rand(100,3))[2:2]
---
Error message

Another cell defining rar contains errors.

👀 Reading hidden code
rr = Tables.rows(rar)
---
Error message

Another cell defining rar contains errors.

Don't panic!
@view rr[1:20]
👀 Reading hidden code
---
sl = @bind x html"<input type=range>"
👀 Reading hidden code
129 ms
a
HTML
1
DataFrame(:a => [html"<input type=range>"])
👀 Reading hidden code
133 ms
🙊Hondjes enzo
AnyWowAny
1

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

2
3
3
begin
sleep(.2)
@info "" x
if !@isdefined(y)
y = 20
end
DataFrame(
"❤" => [sl, (@bind y Slider(1:100, default=y)), 3],
"🙊" => Wow.([6,x,y]),
"Hondjes enzo" => [md"**Wow** dit is echt heel erg veel tekst dit gaat _sowieso_ niet passen in een klein celletje", [img, img], rand(50)]
)
end
👀 Reading hidden code
x
missing
1.0 s

New ✨

👀 Reading hidden code
172 μs
🙊Hondjes enzoCool plots
WowAnyPlot
1

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

2
3
d1 = DataFrame(
# "❤" => [1, 2, 3],
"🙊" => Wow.(6:8),
"Hondjes enzo" => [md"**Wow** dit is echt heel erg veel tekst dit gaat _sowieso_ niet passen in een klein celletje", [img, img], rand(50)],
"Cool plots" => plot.([sin, cos, tan]; size=(200,100))
)
👀 Reading hidden code
633 ms
🙊Hondjes enzo
StringWowAny
1
"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

2
"zdegzenzun"
3
"klqiblqgdh"
d2 = DataFrame(
"❤" => [rand('a':'z', 10) |> String for _ in 1:3],
"🙊" => Wow.(6:8),
"Hondjes enzo" => [md"**Wow** dit is echt heel erg veel tekst dit gaat _sowieso_ niet passen in een klein celletje", [img, img], rand(50)]
)
👀 Reading hidden code
125 ms

DataFrames.jl default

👀 Reading hidden code
185 μs
# old(dbig)
👀 Reading hidden code
8.0 μs
🙊Hondjes enzo❤_1🙊_1Hondjes enzo_1❤_2🙊_2Hondjes enzo_2❤_3🙊_3Hondjes enzo_3
StringWowAnyStringWowAnyStringWowAnyStringWowAny
1
"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

2
"zdegzenzun"
"zdegzenzun"
"zdegzenzun"
"zdegzenzun"
3
"klqiblqgdh"
"klqiblqgdh"
"klqiblqgdh"
"klqiblqgdh"
4
"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

5
"zdegzenzun"
"zdegzenzun"
"zdegzenzun"
"zdegzenzun"
6
"klqiblqgdh"
"klqiblqgdh"
"klqiblqgdh"
"klqiblqgdh"
7
"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

8
"zdegzenzun"
"zdegzenzun"
"zdegzenzun"
"zdegzenzun"
9
"klqiblqgdh"
"klqiblqgdh"
"klqiblqgdh"
"klqiblqgdh"
10
"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

"whknkfxequ"

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

more
36
"klqiblqgdh"
"klqiblqgdh"
"klqiblqgdh"
"klqiblqgdh"
dbig = let
dwide = hcat(d2, d2, d2, d2, makeunique=true)
vcat(dwide, dwide, dwide, dwide, dwide, dwide, dwide, dwide, dwide, dwide, dwide, dwide)
end
👀 Reading hidden code
1.5 s
[1:100...]
👀 Reading hidden code
41.4 μs
0xc6fa1194f222d4dc
ra = rand(UInt)
👀 Reading hidden code
3.7 ms
[
let
a = x
a
end
for x in 1:10
]
👀 Reading hidden code
25.2 μs
200×200 Matrix{Float64}:
 0.497672   0.309232  0.482514  0.425571  …  0.0363394  0.986674   0.590235
 0.609604   0.778475  0.690581  0.102397     0.60049    0.424244   0.249347
 0.83998    0.263602  0.65721   0.553031     0.204759   0.43766    0.40733
 0.0723015  0.402889  0.352859  0.204455     0.0999252  0.0912355  0.542264
 0.288223   0.563537  0.53814   0.450041     0.951201   0.464749   0.317775
 0.64078    0.679326  0.342725  0.494672  …  0.0564509  0.995944   0.855637
 0.231867   0.597798  0.884322  0.386629     0.650199   0.0677996  0.261572
 ⋮                                        ⋱                        
 0.464204   0.787247  0.790565  0.370651     0.340219   0.0450529  0.213854
 0.42354    0.653661  0.971451  0.342682  …  0.257799   0.0651894  0.621675
 0.419182   0.539575  0.270656  0.287291     0.420572   0.451306   0.846693
 0.223562   0.018923  0.350005  0.90433      0.546053   0.664229   0.49845
 0.998644   0.9708    0.464421  0.268596     0.99343    0.882112   0.949236
 0.754496   0.953334  0.754514  0.594292     0.0622556  0.035201   0.142039
rand(200,200)
👀 Reading hidden code
52.5 μs
Error message

ArgumentError: `DataFrame` constructor from a `Matrix` requires passing :auto as a second argument to automatically generate column names: `DataFrame(matrix, :auto)`

Stack trace

Here is what happened, the most recent locations are first:

  1. DataFrames.DataFrame(matrix::Matrix{Float64})
  2. d200 = DataFrame(rand(200,200))
d200 = DataFrame(rand(200,200))
👀 Reading hidden code
---

Here 12 we go "asdf"

12

Asdf Asdf Asdf Asdf Asdf Asdf Asdf Asdf Asdf bbbasfasdf asdf asdf

asdfasdf

md"""
## Here $\frac{1}{2}$ we go "asdf"

$\frac{1}{2}$

Asdf Asdf Asdf Asdf Asdf Asdf Asdf Asdf Asdf
bbbasfasdf asdf asdf

asdfasdf

"""
👀 Reading hidden code
327 μs

👀 Reading hidden code
73.4 μs
asdf asdf
html"""
<b>asdf</b> asdf

"""
👀 Reading hidden code
3.7 ms

👀 Reading hidden code
72.0 μs
plot.([sin,cos])
👀 Reading hidden code
5.0 s
Error message

Another cell defining d200 contains errors.

d200
👀 Reading hidden code
---
using Tables
👀 Reading hidden code
32.8 ms
using Plots
👀 Reading hidden code
3.5 s
0x6464aa3230874934
objectid(Tables.columns(dbig))
👀 Reading hidden code
2.9 ms
collect(1:100)
👀 Reading hidden code
13.2 μs
using DataFrames
👀 Reading hidden code
1.4 s
123
123
👀 Reading hidden code
6.9 μs
struct Wow
x
end
👀 Reading hidden code
939 μs
qalkuccgiq
bjwaojumigo
vlykykysgklsvytoawcdsvpwyulhvthazzzrzlzogohplskptejiosv
babanyepcxieudvgq
rgxchxeqokgyswcqozfkvei
tkuagn
ftnclxxpfwgnqyvyuhwjpcqxnameemdoknukufrguwpgcpmdwbqf
oknibkbselxzlyfycewbkpyufuvjwtmvdnezzzbqfynqgbwvtpolfjcs
nrmhgudeexhdvlmspszugzshl
qpevxexpd
mtmriy
owmdwbzdsnc
c
athfgtruwzcorcebyttmjgriaeb
ftewmahfurjmwdiennwb
n
iuttszpinrualpzuaaipdmelmcyymybzhqjqfaorgsmwzmdpfqkywhcylskphiutpfhdkerehfhclvdihqgk
nstufudfqccluhdxajsafqxpjxsw
nvyhrlyhvqkoqtndpsaapzostchzath
ojcotkienaafxhecpkc
an
bposicabbjgdzimgknibizppioxioukdlzihubfwsldbyqjlxrczgqyqddvvnbwvrqquijnhnzhgfwocalfszylmzqzlxjz
vftpqkfijsjxkztlnltigmiyamcyovpdbbjcbumrdkpfjo
rzkwkzblwr
fl
bnos
wcrqztqpuymavbxhfohmu
etvonrmjhfonlmkcmoyykyqhwpkjnlhq
pmrysyuvwzzjodusktxrjct
pplzzjaxhwtfvmhydnbonojuyjoudylpptuxlkhsptckxsvilxxnudjeqbjjsjdjdmblobvyjxgoiek
ripxvtjukrnarjogdivhsqlcsm
fe
rtkntypliokymtqidxwbwpzkbogivlajydxbvrlrigfzexxjy
hiibnvabrlip
exs
axkilfvbismmkngugczbhqboke
stkkpmcdobqyvmmqdys
quvzgaxddtcwczztyaim
rand(['a':'z'..., '\n'], 1000) |> String |> Text
👀 Reading hidden code
3.6 ms
collect(1:50)
👀 Reading hidden code
15.3 μs

img = md"![](https://fonsp.com/img/doggoSmall.jpg?raw=true)"
👀 Reading hidden code
26.6 ms
using PlutoUI
👀 Reading hidden code
120 ms
a
Int64
1
1
2
2
3
3
4
4
5
5
6
6
7
7
8
8
9
9
10
10
more
1000
1000
d3 = DataFrame(:a => 1:1000)
👀 Reading hidden code
13.4 ms
123
convert(Int64, UInt16(123))
👀 Reading hidden code
2.1 ms
asdf (generic function with 1 method)
asdf(x::Int64) = x
👀 Reading hidden code
354 μs
Error message

MethodError: no method matching asdf(::UInt16)

Closest candidates are:

asdf(::Int64) at ~/work/disorganised-mess/disorganised-mess/tables/some dataframes.jl#==#c6d7db6a-2293-11eb-23e6-b982c992e486:1

Stack trace

Here is what happened, the most recent locations are first:

  1. asdf(UInt16(123))
asdf(UInt16(123))
👀 Reading hidden code
---
3×3 DataFrame
Row🙊Hondjes enzo
StringWowAny
1whknkfxequWow(6)

Wow dit is echt heel erg veel tekst dit gaat sowieso niet passen in een klein celletje

2zdegzenzunWow(7)Markdown.MD[![](https://fonsp.com/img/doggoSmall.jpg?raw=true)\n, ![](https://fonsp.com/img/doggoSmall.jpg?raw=true)\n]
3klqiblqgdhWow(8)[0.955512, 0.0780774, 0.989846, 0.169209, 0.767329, 0.095582, 0.0264209, 0.844893, 0.317467, 0.270954 … 0.513635, 0.377386, 0.969254, 0.702293, 0.102918, 0.807858, 0.000272183, 0.208902, 0.525819, 0.880319]
old(d2)
👀 Reading hidden code
1.3 s
IOContext(Base.DevNull())
default_iocontext = IOContext(devnull, :color => false, :limit => true, :displaysize => (18, 88))
👀 Reading hidden code
25.5 μs
old (generic function with 1 method)
old(x) = HTML(repr(MIME"text/html"(), x; context=default_iocontext))
👀 Reading hidden code
3.0 ms
<div>
<div style = "float: left;">
<span>3×3 DataFrame</span>
</div>
<div style = "clear: both;">
</div>
</div>
<div class = "data-frame" style = "overflow-x: scroll;">
<table class = "data-frame" style = "margin-bottom: 6px;">
<thead>
<tr class = "header">
<th class = "rowNumber" style = "font-weight: bold; text-align: right;">Row</th>
<th style = "text-align: left;">🙊</th>
<th style = "text-align: left;">Hondjes enzo</th>
<th style = "text-align: left;">Cool plots</th>
</tr>
<tr class = "subheader headerLastRow">
<th class = "rowNumber" style = "font-weight: bold; text-align: right;">
</th>
<th title = "Main.workspace#6.Wow" style = "text-align: left;">Wow</th>
<th title = "Any" style = "text-align: left;">Any</th>
<th title = "Plots.Plot{Plots.GRBackend}" style = "text-align: left;">Plot…</th>
</tr>
</thead>
<tbody>
<tr>
<td class = "rowNumber" style = "font-weight: bold; text-align: right;">1</td>
<td style = "text-align: left;">Wow(6)</td>
<td style = "text-align: left;">
<div class="markdown">
<p>
<strong>Wow</strong> dit is echt heel erg veel tekst dit gaat <em>sowieso</em> niet passen in een klein celletje</p>
</div>
</td>
<td style = "text-align: left;">Plot{Plots.GRBackend() n=1}</td>
</tr>
<tr>
<td class = "rowNumber" style = "font-weight: bold; text-align: right;">2</td>
<td style = "text-align: left;">Wow(7)</td>
<td style = "text-align: left;">Markdown.MD[![](https://fonsp.com/img/doggoSmall.jpg?raw=true)\n, ![](https://fonsp.com/img/doggoSmall.jpg?raw=true)\n]</td>
<td style = "text-align: left;">Plot{Plots.GRBackend() n=1}</td>
</tr>
<tr>
<td class = "rowNumber" style = "font-weight: bold; text-align: right;">3</td>
<td style = "text-align: left;">Wow(8)</td>
<td style = "text-align: left;">[0.891546, 0.919321, 0.125264, 0.312443, 0.466913, 0.556688, 0.619648, 0.161927, 0.543148, 0.979852  …  0.239844, 0.282591, 0.876115, 0.383545, 0.682908, 0.622377, 0.562783, 0.718207, 0.9014, 0.202852]</td>
<td style = "text-align: left;">Plot{Plots.GRBackend() n=1}</td>
</tr>
</tbody>
</table>
</div>
replace(repr(MIME"text/html"(), d1), "><"=>">\n<") |> Text
👀 Reading hidden code
63.6 ms
(This table has no columns)
(This table has no rows)
DataFrame()
👀 Reading hidden code
12.5 μs
Error message

ArgumentError: `DataFrame` constructor from a `Matrix` requires passing :auto as a second argument to automatically generate column names: `DataFrame(matrix, :auto)`

Stack trace

Here is what happened, the most recent locations are first:

  1. DataFrames.DataFrame(matrix::Matrix{Float64})
  2. DataFrame(rand(20,2000))
DataFrame(rand(20,2000))
👀 Reading hidden code
---
Error message

ArgumentError: `DataFrame` constructor from a `Matrix` requires passing :auto as a second argument to automatically generate column names: `DataFrame(matrix, :auto)`

Stack trace

Here is what happened, the most recent locations are first:

  1. DataFrames.DataFrame(matrix::Matrix{Int64})
  2. DataFrame(rand(1:9,2002,200))
DataFrame(rand(1:9,2002,200))
👀 Reading hidden code
---
Error message

ArgumentError: `DataFrame` constructor from a `Matrix` requires passing :auto as a second argument to automatically generate column names: `DataFrame(matrix, :auto)`

Stack trace

Here is what happened, the most recent locations are first:

  1. DataFrames.DataFrame(matrix::Matrix{Float64})
  2. DataFrame(rand(2000,20))
¯\_(ツ)_/¯
DataFrame(rand(2000,20))
👀 Reading hidden code
---
collect(1:200)
👀 Reading hidden code
13.3 μs